class CreatePlans < ActiveRecord::Migration		
  def self.up		
    create_table :plans do |t|		
	t.column	:id,	:INT
	t.column	:party_id,	:INT
	t.column	:exp_start_date,	:datetime
	t.column	:exp_end_date,	:datetime
	t.column	:exp_cost,	:INT
	t.column	:exp_weather,	:string
	t.column	:assemble,	:string
	t.column	:limit_count,	:INT
	t.column	:equipment,	:string
	t.column	:travel_path,	:string
	t.column	:bus_station,	:string
	t.column	:type,	:string
	t.column	:expire,	:datetime
	t.column	:create_date,	:DATE
	t.column	:status,	:INT
	t.column	:cancle_reason,	:string
        t.timestamps		
    end		
  end		
		
  def self.down		
    drop_table :plans		
  end		
end		
